-- Required parameters: STAGING_DATABASE_NAME, FILEGROUP_NAME, FILE_PATH

ALTER DATABASE $(STAGING_DATABASE_NAME) 
    ADD FILEGROUP $(FILEGROUP_NAME)
GO

ALTER DATABASE $(STAGING_DATABASE_NAME)
    ADD FILE ( 
        NAME = $(FILEGROUP_NAME)_FILE,
        FILENAME = '$(FILE_PATH)'
    )
    TO FILEGROUP $(FILEGROUP_NAME)
GO
